if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BodyType]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[BodyType]
GO

CREATE TABLE [dbo].[BodyType] (
	[BodyTypeId] [INT] IDENTITY (1, 1) NOT NULL ,
	[BodyDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

